Labels:text | screenshot | font | number | paper OCR: Table The fundamental SQL database object that defines the structure of a database. A table consists of columns (sometimes called fields). Each item of data in the table is known as a row (sometimes called a record). Each column has a name, a data type, and special constraints, including nullability (whether the column is required to have data), ref- erential integrity (restrictions based on data in other tables), and check constraints (any general restrictions on the value of the data). The Delphi component Tlable corresponds to a table. View A virtual table, based on the definitions of other tables. Domain A global column definition that can be used in defining tables; something like a user-defined data type. Stored procedure A self-contained program that can receive input parameters from, and return values to, applica- tions, The Delphi component TStoredProc corre- sponds to a stored procedure. Trigger Conceptually similar to a Delphi event, a self- contained routine associated with a table or view that automatically performs an action when a row is inserted, updated, or deleted, Index Used to improve the speed of data retrieval. Identifies columns that can be used to retrieve a unique row and sort rows. Slightly different than the concept of an index in desktop databases like Paradox and dBASE Generator A simple function that generates unique num- bers (usually for use in an index), Function A user-defined function. Filter A BLOb filter. Exception Unrelated to Delphi exceptions
